﻿using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace EasyLucky.Dal.Dal
{
    public class BaseDal
    {
        public SqlSugarClient GetClient()
        {
            SqlSugarClient dbClient = new SqlSugarClient(new ConnectionConfig()
            {
                ConnectionString = $"datasource={Environment.CurrentDirectory}\\easylucky.db",
                DbType = DbType.Sqlite,
                IsAutoCloseConnection = true,
            },
                db =>
                {

                    db.Aop.OnLogExecuting = (sql, pars) =>
                    {

                        //获取原生SQL推荐 5.1.4.63  性能OK
                        Console.WriteLine(UtilMethods.GetNativeSql(sql, pars));
                        //获取无参数化SQL 对性能有影响，特别大的SQL参数多的，调试使用
                        //Console.WriteLine(UtilMethods.GetSqlString(DbType.SqlServer,sql,pars))
                    };
                });
            return dbClient;
        }
    }
}
